Customer Data Report

Dataset info

Number of variables	67
Number of observations	13604
Missing cells	101152 (11.1%)
Duplicate rows	0 (0.0%)
Total size in memory	7.0 MiB
Average record size in memory	536.0 B

Variables types

Numeric	34
Categorical	2
Boolean	0
Date	0
URL	0
Text (Unique)	1
Rejected	30
Unsupported	0

Warnings

`avg_cash_1m` is highly skewed (γ1 = 103.689676)	Skewed
`avg_cash_1m` has 1794 (13.2%) missing values	Missing
`avg_cash_3m` is highly correlated with `avg_cash_1m` (ρ = 0.999099545)	Rejected
`avg_cash_6m` is highly correlated with `avg_cash_3m` (ρ = 0.9936676512)	Rejected
`avg_loan_1m` has 9723 (71.5%) missing values	Missing
`avg_loan_3m` is highly correlated with `avg_loan_1m` (ρ = 0.982995212)	Rejected
`avg_loan_6m` is highly correlated with `avg_loan_3m` (ρ = 0.9830235048)	Rejected
`avg_portfolio_value_1m` is highly skewed (γ1 = 57.17590837)	Skewed
`avg_portfolio_value_3m` is highly correlated with `avg_portfolio_value_1m` (ρ = 0.994578141)	Rejected
`avg_portfolio_value_6m` is highly correlated with `avg_portfolio_value_3m` (ρ = 0.9904928022)	Rejected
`avg_profit_per_6m` has 6566 (48.3%) missing values	Missing
`avg_stock_count_1m` is highly skewed (γ1 = 35.66018242)	Skewed
`avg_stock_count_3m` is highly correlated with `avg_stock_count_1m` (ρ = 0.9902316431)	Rejected
`avg_stock_count_6m` is highly correlated with `avg_stock_count_3m` (ρ = 0.9945684363)	Rejected
`buy_order` has 11966 (88.0%) zeros	Zeros
`buy_order_1m` has 7919 (58.2%) zeros	Zeros
`buy_order_3m` has 5945 (43.7%) zeros	Zeros
`buy_order_6m` is highly correlated with `buy_order_3m` (ρ = 0.9541051671)	Rejected
`buy_orders_1m_3m_per` has 1974 (14.5%) zeros	Zeros
`buy_orders_1m_6m_per` has 3104 (22.8%) zeros	Zeros
`cash_vs_1m` has 6937 (51.0%) zeros	Zeros
`cash_vs_1m` has 2142 (15.7%) missing values	Missing
`cash_vs_3m` is highly correlated with `cash_vs_1m` (ρ = 0.9177938753)	Rejected
`cash_vs_6m` is highly correlated with `cash_vs_3m` (ρ = 0.9191843439)	Rejected
`CashBalance` is highly correlated with `cash_vs_6m` (ρ = 0.9575212639)	Rejected
`loan_vs_1m` has 406 (3.0%) zeros	Zeros
`loan_vs_1m` has 10235 (75.2%) missing values	Missing
`loan_vs_3m` has 10235 (75.2%) missing values	Missing
`loan_vs_6m` is highly correlated with `loan_vs_3m` (ρ = 0.9634403754)	Rejected
`LoanBalance` is highly correlated with `avg_loan_3m` (ρ = 0.9520490662)	Rejected
`num_oder` has 11385 (83.7%) zeros	Zeros
`port_value_vs_1m` is highly skewed (γ1 = 56.33449157)	Skewed
`port_value_vs_1m` has 333 (2.4%) zeros	Zeros
`port_value_vs_3m` has 257 (1.9%) zeros	Zeros
`port_value_vs_6m` is highly correlated with `port_value_vs_3m` (ρ = 0.9076132457)	Rejected
`portfolio_value` is highly correlated with `avg_portfolio_value_6m` (ρ = 0.9673778626)	Rejected
`profit` is highly skewed (γ1 = 25.84513152)	Skewed
`profit` has 12447 (91.5%) zeros	Zeros
`profit_1m` has 8893 (65.4%) zeros	Zeros
`profit_3m` is highly skewed (γ1 = 115.58013)	Skewed
`profit_3m` has 7316 (53.8%) zeros	Zeros
`profit_6m` is highly correlated with `profit_3m` (ρ = 0.9943629294)	Rejected
`profit_per` has 12437 (91.4%) missing values	Missing
`region` has a high cardinality: 71 distinct values	Warning
`sell_order` has 12437 (91.4%) zeros	Zeros
`sell_order_1m` has 8865 (65.2%) zeros	Zeros
`sell_order_3m` is highly correlated with `sell_order_1m` (ρ = 0.9065289845)	Rejected
`sell_order_6m` is highly correlated with `sell_order_3m` (ρ = 0.9577278331)	Rejected
`sell_order_gain` has 12944 (95.1%) zeros	Zeros
`sell_order_loss` has 12942 (95.1%) zeros	Zeros
`sell_orders_1m_3m_per` has 1568 (11.5%) zeros	Zeros
`sell_orders_1m_6m_per` has 2299 (16.9%) zeros	Zeros
`stock_count` is highly correlated with `avg_stock_count_6m` (ρ = 0.967179082)	Rejected
`stock_count_vs_1m` has 10985 (80.7%) zeros	Zeros
`stock_count_vs_3m` has 9952 (73.2%) zeros	Zeros
`stock_count_vs_6m` is highly correlated with `stock_count_vs_3m` (ρ = 0.9005250291)	Rejected
`total_buy_order_1m_3m_per` is highly correlated with `buy_orders_1m_3m_per` (ρ = 0.9809048155)	Rejected
`total_buy_order_1m_6m_per` is highly correlated with `buy_orders_1m_6m_per` (ρ = 0.9834419742)	Rejected
`total_buy_value` is highly skewed (γ1 = 33.59928488)	Skewed
`total_buy_value` has 11966 (88.0%) zeros	Zeros
`total_buy_value_1m` is highly skewed (γ1 = 111.4168123)	Skewed
`total_buy_value_1m` has 7920 (58.2%) zeros	Zeros
`total_buy_value_3m` is highly correlated with `total_buy_value_1m` (ρ = 0.9484353291)	Rejected
`total_buy_value_6m` is highly skewed (γ1 = 99.82045008)	Skewed
`total_buy_value_6m` has 4822 (35.4%) zeros	Zeros
`total_sell_order_1m_3m_per` is highly correlated with `sell_orders_1m_3m_per` (ρ = 0.9806879469)	Rejected
`total_sell_order_1m_6m_per` is highly correlated with `sell_orders_1m_6m_per` (ρ = 0.9863198197)	Rejected
`total_sell_value` is highly skewed (γ1 = 32.59792884)	Skewed
`total_sell_value` has 12437 (91.4%) zeros	Zeros
`total_sell_value_1m` is highly skewed (γ1 = 76.04338338)	Skewed
`total_sell_value_1m` has 8867 (65.2%) zeros	Zeros
`total_sell_value_3m` is highly correlated with `profit_6m` (ρ = 0.9617840254)	Rejected
`total_sell_value_6m` is highly correlated with `total_sell_value_3m` (ρ = 0.988218788)	Rejected
`trading_date` has constant value "2019-09-30"	Rejected
`trading_month` has constant value "9"	Rejected

Age
Numeric

Distinct count	79
Unique (%)	0.6%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	39.34776536
Minimum	0
Maximum	94
Zeros (%)	0.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	24
Q1	31
Median	38
Q3	45
95-th percentile	62
Maximum	94
Range	94
Interquartile range	14

Descriptive statistics

Standard deviation	11.78569364
Coef of variation	0.299526378
Kurtosis	1.096228827
Mean	39.34776536
MAD	9.008705951
Skewness	0.4923783728
Sum	535287
Variance	138.9025746
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 1.5 18.5 20.5 23.5 ... 66.5 70.5 73.5 80.5 94. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
36	639	4.7%
35	632	4.6%
38	571	4.2%
37	567	4.2%
34	545	4.0%
30	515	3.8%
32	502	3.7%
39	497	3.7%
31	493	3.6%
29	468	3.4%
Other values (69)	8175	60.1%

Minimum 5 values

Value	Count	Frequency (%)
0	116	0.9%
3	1	< 0.1%
4	4	< 0.1%
6	1	< 0.1%
9	2	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
94	1	< 0.1%
89	1	< 0.1%
88	1	< 0.1%
87	1	< 0.1%
86	1	< 0.1%

avg_cash_1m
Numeric

Distinct count	11592
Unique (%)	85.2%
Missing (%)	13.2%
Missing (n)	1794
Infinite (%)	0.0%
Infinite (n)	0

Mean	91789808.97
Minimum	1
Maximum	5.868472227e+11
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	2453.75
Q1	98256
Median	943260.725
Q3	8656386.975
95-th percentile	102519827.9
Maximum	5.868472227e+11
Range	5.868472227e+11
Interquartile range	8558130.975

Descriptive statistics

Standard deviation	5495863568
Coef of variation	59.87444173
Kurtosis	11016.55324
Mean	91789808.97
MAD	159437380.5
Skewness	103.689676
Sum	1.084037644e+12
Variance	3.020451636e+19
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
220064	16	0.1%
342414	10	0.1%
1	7	0.1%
17	5	< 0.1%
219	5	< 0.1%
5	5	< 0.1%
179	5	< 0.1%
2300	4	< 0.1%
71	4	< 0.1%
1096	4	< 0.1%
Other values (11581)	11745	86.3%
(Missing)	1794	13.2%

Minimum 5 values

Value	Count	Frequency (%)
1	7	0.1%
2	2	< 0.1%
3	2	< 0.1%
4	2	< 0.1%
5	5	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
5.868472227e+11	1	< 0.1%
1.066013554e+11	1	< 0.1%
1.661310946e+10	1	< 0.1%
1.402131235e+10	1	< 0.1%
1.172530387e+10	1	< 0.1%

avg_cash_3m
Highly correlated

This variable is highly correlated with avg_cash_1m and should be ignored for analysis

Correlation	0.999099545

avg_cash_6m
Highly correlated

This variable is highly correlated with avg_cash_3m and should be ignored for analysis

Correlation	0.9936676512

avg_loan_1m
Numeric

Distinct count	3880
Unique (%)	28.5%
Missing (%)	71.5%
Missing (n)	9723
Infinite (%)	0.0%
Infinite (n)	0

Mean	1079097733
Minimum	1
Maximum	1.761755415e+11
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1029127
Q1	29696319
Median	113664492.8
Q3	384190409.4
95-th percentile	3110180832
Maximum	1.761755415e+11
Range	1.761755415e+11
Interquartile range	354494090.4

Descriptive statistics

Standard deviation	6563522764
Coef of variation	6.082417344
Kurtosis	339.9789419
Mean	1079097733
MAD	1590451153
Skewness	16.23951948
Sum	4.1879783e+12
Variance	4.307983107e+19
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	3	< 0.1%
587101517.6	1	< 0.1%
8300358	1	< 0.1%
128178611.4	1	< 0.1%
215276311	1	< 0.1%
8473931	1	< 0.1%
857295	1	< 0.1%
3184863297	1	< 0.1%
644665.8947	1	< 0.1%
51720091.75	1	< 0.1%
Other values (3869)	3869	28.4%
(Missing)	9723	71.5%

Minimum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	3	< 0.1%
5	1	< 0.1%
9	1	< 0.1%
13	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1.761755415e+11	1	< 0.1%
1.62746467e+11	1	< 0.1%
1.501863354e+11	1	< 0.1%
1.017458212e+11	1	< 0.1%
9.688517257e+10	1	< 0.1%

avg_loan_3m
Highly correlated

This variable is highly correlated with avg_loan_1m and should be ignored for analysis

Correlation	0.982995212

avg_loan_6m
Highly correlated

This variable is highly correlated with avg_loan_3m and should be ignored for analysis

Correlation	0.9830235048

avg_portfolio_value_1m
Numeric

Distinct count	12413
Unique (%)	91.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	3511439829
Minimum	0
Maximum	6.726841428e+12
Zeros (%)	0.8%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	52717.25
Q1	2912511.625
Median	46092690
Q3	255812375
95-th percentile	2360454725
Maximum	6.726841428e+12
Range	6.726841428e+12
Interquartile range	252899863.4

Descriptive statistics

Standard deviation	8.041718837e+10
Coef of variation	22.90148551
Kurtosis	4125.929071
Mean	3511439829
MAD	6319753027
Skewness	57.17590837
Sum	4.776962744e+13
Variance	6.466924185e+21
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e+02 2.06387500e+04 2.06700000e+04 2.08662500e+04 ... 4.81522715e+10 9.49506765e+10 1.86592868e+11 8.11948812e+11 6.72684143e+12], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	106	0.8%
271375	67	0.5%
167000	49	0.4%
62625	44	0.3%
41750	40	0.3%
61965	34	0.2%
146125	33	0.2%
229625	32	0.2%
2254965	31	0.2%
343477250	25	0.2%
Other values (12403)	13143	96.6%

Minimum 5 values

Value	Count	Frequency (%)
0	106	0.8%
1000	1	< 0.1%
1320	1	< 0.1%
1400	1	< 0.1%
1500	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
6.726841428e+12	1	< 0.1%
3.895901932e+12	1	< 0.1%
2.372319836e+12	1	< 0.1%
1.9923722e+12	1	< 0.1%
1.734016099e+12	1	< 0.1%

avg_portfolio_value_3m
Highly correlated

This variable is highly correlated with avg_portfolio_value_1m and should be ignored for analysis

Correlation	0.994578141

avg_portfolio_value_6m
Highly correlated

This variable is highly correlated with avg_portfolio_value_3m and should be ignored for analysis

Correlation	0.9904928022

avg_profit_per_6m
Numeric

Distinct count	6925
Unique (%)	50.9%
Missing (%)	48.3%
Missing (n)	6566
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.007628454389
Minimum	-1
Maximum	3.711188321
Zeros (%)	0.3%

Toggle details

Quantile statistics

Minimum	-1
5-th percentile	-0.1130861688
Q1	-0.02931301111
Median	-0.004450231505
Q3	0.02467667158
95-th percentile	0.1627218557
Maximum	3.711188321
Range	4.711188321
Interquartile range	0.05398968269

Descriptive statistics

Standard deviation	0.1288179404
Coef of variation	16.88650595
Kurtosis	150.3202316
Mean	0.007628454389
MAD	0.06029826319
Skewness	6.896232708
Sum	53.68906199
Variance	0.01659406178
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	36	0.3%
-1	5	< 0.1%
-0.06015037594	4	< 0.1%
0.02510460251	4	< 0.1%
0.1	3	< 0.1%
0.07692307692	3	< 0.1%
0.1052631579	3	< 0.1%
0.02941176471	3	< 0.1%
-0.03759398496	3	< 0.1%
-0.1578947368	3	< 0.1%
Other values (6914)	6971	51.2%
(Missing)	6566	48.3%

Minimum 5 values

Value	Count	Frequency (%)
-1	5	< 0.1%
-0.9249146758	1	< 0.1%
-0.8531955146	1	< 0.1%
-0.7726784756	1	< 0.1%
-0.6626180837	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
3.711188321	1	< 0.1%
2.743654822	1	< 0.1%
1.676056338	1	< 0.1%
1.610399146	1	< 0.1%
1.444444444	1	< 0.1%

avg_stock_count_1m
Numeric

Distinct count	650
Unique (%)	4.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.156561785
Minimum	1
Maximum	393
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	2
Q3	4
95-th percentile	9
Maximum	393
Range	392
Interquartile range	3

Descriptive statistics

Standard deviation	5.183603105
Coef of variation	1.642167478
Kurtosis	2424.765045
Mean	3.156561785
MAD	2.223472217
Skewness	35.66018242
Sum	42941.86652
Variance	26.86974115
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 1. 1.025 1.05409357 1.09545455 1.10263158 ... 16.025 22.15 35.675 120.475 393. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	5012	36.8%
2	1732	12.7%
3	917	6.7%
4	576	4.2%
5	338	2.5%
6	214	1.6%
7	135	1.0%
8	104	0.8%
9	63	0.5%
10	60	0.4%
Other values (640)	4453	32.7%

Minimum 5 values

Value	Count	Frequency (%)
1	5012	36.8%
1.05	52	0.4%
1.052631579	8	0.1%
1.055555556	1	< 0.1%
1.058823529	4	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
393	1	< 0.1%
121.2	1	< 0.1%
119.75	1	< 0.1%
111.95	1	< 0.1%
109.9	1	< 0.1%

avg_stock_count_3m
Highly correlated

This variable is highly correlated with avg_stock_count_1m and should be ignored for analysis

Correlation	0.9902316431

avg_stock_count_6m
Highly correlated

This variable is highly correlated with avg_stock_count_3m and should be ignored for analysis

Correlation	0.9945684363

buy_order
Numeric

Distinct count	10
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.1789914731
Minimum	0
Maximum	9
Zeros (%)	88.0%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	1
Maximum	9
Range	9
Interquartile range	0

Descriptive statistics

Standard deviation	0.5852430512
Coef of variation	3.269670008
Kurtosis	34.92799677
Mean	0.1789914731
MAD	0.3148797364
Skewness	4.92497328
Sum	2435
Variance	0.342509429
Memory size	106.4 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 4.5 6.5 9. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	11966	88.0%
1	1146	8.4%
2	317	2.3%
3	99	0.7%
4	47	0.3%
5	15	0.1%
6	9	0.1%
9	2	< 0.1%
8	2	< 0.1%
7	1	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	11966	88.0%
1	1146	8.4%
2	317	2.3%
3	99	0.7%
4	47	0.3%

Maximum 5 values

Value	Count	Frequency (%)
9	2	< 0.1%
8	2	< 0.1%
7	1	< 0.1%
6	9	0.1%
5	15	0.1%

buy_order_1m
Numeric

Distinct count	82
Unique (%)	0.6%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.877389003
Minimum	0
Maximum	258
Zeros (%)	58.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	3
95-th percentile	14
Maximum	258
Range	258
Interquartile range	3

Descriptive statistics

Standard deviation	7.309659159
Coef of variation	2.540379195
Kurtosis	158.3257298
Mean	2.877389003
MAD	3.8247429
Skewness	8.328488898
Sum	39144
Variance	53.43111702
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 4.5 ... 37.5 49.5 68.5 129. 258. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	7919	58.2%
1	1354	10.0%
2	784	5.8%
3	580	4.3%
4	490	3.6%
5	361	2.7%
6	268	2.0%
7	257	1.9%
8	207	1.5%
9	170	1.2%
Other values (72)	1214	8.9%

Minimum 5 values

Value	Count	Frequency (%)
0	7919	58.2%
1	1354	10.0%
2	784	5.8%
3	580	4.3%
4	490	3.6%

Maximum 5 values

Value	Count	Frequency (%)
258	1	< 0.1%
130	1	< 0.1%
128	1	< 0.1%
127	1	< 0.1%
109	1	< 0.1%

buy_order_3m
Numeric

Distinct count	180
Unique (%)	1.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.183990003
Minimum	0
Maximum	793
Zeros (%)	43.7%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	1
Q3	9
95-th percentile	42
Maximum	793
Range	793
Interquartile range	9

Descriptive statistics

Standard deviation	22.76311838
Coef of variation	2.478565239
Kurtosis	187.4377834
Mean	9.183990003
MAD	11.61070418
Skewness	9.475589842
Sum	124939
Variance	518.1595584
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.500e+00 2.500e+00 4.500e+00 ... 8.850e+01 1.365e+02 1.760e+02 2.305e+02 7.930e+02], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	5945	43.7%
1	1435	10.5%
2	645	4.7%
3	428	3.1%
4	397	2.9%
5	334	2.5%
6	300	2.2%
7	285	2.1%
8	237	1.7%
9	212	1.6%
Other values (170)	3386	24.9%

Minimum 5 values

Value	Count	Frequency (%)
0	5945	43.7%
1	1435	10.5%
2	645	4.7%
3	428	3.1%
4	397	2.9%

Maximum 5 values

Value	Count	Frequency (%)
793	1	< 0.1%
534	1	< 0.1%
474	1	< 0.1%
425	1	< 0.1%
408	1	< 0.1%

buy_order_6m
Highly correlated

This variable is highly correlated with buy_order_3m and should be ignored for analysis

Correlation	0.9541051671

buy_orders_1m_3m_per
Numeric

Distinct count	711
Unique (%)	5.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.6373202265
Minimum	0
Maximum	1
Zeros (%)	14.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.2307692308
Median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range	0.7692307692

Descriptive statistics

Standard deviation	0.4105736767
Coef of variation	0.644218808
Kurtosis	-1.556919134
Mean	0.6373202265
MAD	0.3867238175
Skewness	-0.4316511474
Sum	8670.104362
Variance	0.168570744
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0. 0.00961538 0.03077652 0.04880952 0.08248299 ... 0.79473684 0.80384615 0.93095238 0.99193548 1. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	7124	52.4%
0	1974	14.5%
0.5	330	2.4%
0.3333333333	274	2.0%
0.25	205	1.5%
0.2	171	1.3%
0.6666666667	120	0.9%
0.1666666667	116	0.9%
0.2857142857	103	0.8%
0.4	96	0.7%
Other values (701)	3091	22.7%

Minimum 5 values

Value	Count	Frequency (%)
0	1974	14.5%
0.01923076923	1	< 0.1%
0.02040816327	1	< 0.1%
0.02222222222	1	< 0.1%
0.0243902439	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1	7124	52.4%
0.9838709677	1	< 0.1%
0.9705882353	1	< 0.1%
0.9666666667	1	< 0.1%
0.9545454545	1	< 0.1%

buy_orders_1m_6m_per
Numeric

Distinct count	967
Unique (%)	7.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.5155653086
Minimum	0
Maximum	1
Zeros (%)	22.8%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.05263157895
Median	0.3888888889
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range	0.9473684211

Descriptive statistics

Standard deviation	0.4413275791
Coef of variation	0.856007128
Kurtosis	-1.82370802
Mean	0.5155653086
MAD	0.4222348346
Skewness	0.05300237862
Sum	7013.750458
Variance	0.1947700321
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0. 0.004 0.01299578 0.03200205 0.05245958 ... 0.79285714 0.80384615 0.93095238 0.99193548 1. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	5756	42.3%
0	3104	22.8%
0.5	256	1.9%
0.3333333333	195	1.4%
0.25	161	1.2%
0.2	127	0.9%
0.1666666667	114	0.8%
0.125	104	0.8%
0.1428571429	100	0.7%
0.1111111111	98	0.7%
Other values (957)	3589	26.4%

Minimum 5 values

Value	Count	Frequency (%)
0	3104	22.8%
0.008	1	< 0.1%
0.01265822785	1	< 0.1%
0.01333333333	1	< 0.1%
0.01351351351	2	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1	5756	42.3%
0.9838709677	1	< 0.1%
0.9705882353	1	< 0.1%
0.9666666667	1	< 0.1%
0.9545454545	1	< 0.1%

cash_vs_1m
Numeric

Distinct count	4405
Unique (%)	32.4%
Missing (%)	15.7%
Missing (n)	2142
Infinite (%)	0.0%
Infinite (n)	0

Mean	726967.6534
Minimum	-7.584724702e+10
Maximum	5.157112255e+10
Zeros (%)	51.0%

Toggle details

Quantile statistics

Minimum	-7.584724702e+10
5-th percentile	-25941612.48
Q1	0
Median	0
Q3	0
95-th percentile	12457042.61
Maximum	5.157112255e+10
Range	1.274183696e+11
Interquartile range	0

Descriptive statistics

Standard deviation	1012981537
Coef of variation	1393.434127
Kurtosis	3541.586039
Mean	726967.6534
MAD	37767879.09
Skewness	-18.62859592
Sum	8332503244
Variance	1.026131595e+18
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6937	51.0%
3230	8	0.1%
19380	6	< 0.1%
193800	6	< 0.1%
161500	6	< 0.1%
9500	5	< 0.1%
475	5	< 0.1%
16150	5	< 0.1%
5776	4	< 0.1%
47500	4	< 0.1%
Other values (4394)	4476	32.9%
(Missing)	2142	15.7%

Minimum 5 values

Value	Count	Frequency (%)
-7.584724702e+10	1	< 0.1%
-1.415609146e+10	1	< 0.1%
-1.355085659e+10	1	< 0.1%
-5878022982	1	< 0.1%
-4415000000	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
5.157112255e+10	1	< 0.1%
3.247732373e+10	1	< 0.1%
2.927193892e+10	1	< 0.1%
2.84647159e+10	1	< 0.1%
8340618029	1	< 0.1%

cash_vs_3m
Highly correlated

This variable is highly correlated with cash_vs_1m and should be ignored for analysis

Correlation	0.9177938753

cash_vs_6m
Highly correlated

This variable is highly correlated with cash_vs_3m and should be ignored for analysis

Correlation	0.9191843439

CashBalance
Highly correlated

This variable is highly correlated with cash_vs_6m and should be ignored for analysis

Correlation	0.9575212639

Gender
Categorical

Distinct count	4
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	59

M	7553
F	5985
O	7
(Missing)	59

Toggle details

Common values
Composition

Value	Count	Frequency (%)
M	7553	55.5%
F	5985	44.0%
O	7	0.1%
(Missing)	59	0.4%

Max length	4
Mean length	1.013010879
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

loan_vs_1m
Numeric

Distinct count	2956
Unique (%)	21.7%
Missing (%)	75.2%
Missing (n)	10235
Infinite (%)	0.0%
Infinite (n)	0

Mean	70477019.99
Minimum	-3.389330217e+10
Maximum	2.273403394e+10
Zeros (%)	3.0%

Toggle details

Quantile statistics

Minimum	-3.389330217e+10
5-th percentile	-171073408.6
Q1	-8086008.75
Median	0
Q3	39859560
95-th percentile	463757292
Maximum	2.273403394e+10
Range	5.662733611e+10
Interquartile range	47945568.75

Descriptive statistics

Standard deviation	1138549436
Coef of variation	16.1549032
Kurtosis	343.0113857
Mean	70477019.99
MAD	241497658.9
Skewness	-4.31810607
Sum	2.374370803e+11
Variance	1.296294818e+18
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	406	3.0%
-2375000	2	< 0.1%
-13326.4	2	< 0.1%
1479363.636	2	< 0.1%
-4275000	2	< 0.1%
-20548500	2	< 0.1%
-760000	2	< 0.1%
-6750000000	2	< 0.1%
-50000	2	< 0.1%
-361667.7	2	< 0.1%
Other values (2945)	2945	21.6%
(Missing)	10235	75.2%

Minimum 5 values

Value	Count	Frequency (%)
-3.389330217e+10	1	< 0.1%
-1.866150068e+10	1	< 0.1%
-1.319341883e+10	1	< 0.1%
-6750000000	2	< 0.1%
-6009409406	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
2.273403394e+10	1	< 0.1%
1.478023073e+10	1	< 0.1%
1.44956863e+10	1	< 0.1%
1.382210686e+10	1	< 0.1%
1.347580698e+10	1	< 0.1%

loan_vs_3m
Numeric

Distinct count	3260
Unique (%)	24.0%
Missing (%)	75.2%
Missing (n)	10235
Infinite (%)	0.0%
Infinite (n)	0

Mean	111324959.6
Minimum	-5.988427975e+10
Maximum	3.274134179e+10
Zeros (%)	0.8%

Toggle details

Quantile statistics

Minimum	-5.988427975e+10
5-th percentile	-241272083.1
Q1	-16208625
Median	2250306.262
Q3	70211272.04
95-th percentile	742796138.9
Maximum	3.274134179e+10
Range	9.262562155e+10
Interquartile range	86419897.04

Descriptive statistics

Standard deviation	2190818630
Coef of variation	19.67949181
Kurtosis	412.1779
Mean	111324959.6
MAD	394694935
Skewness	-11.44564399
Sum	3.750537888e+11
Variance	4.79968627e+18
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	111	0.8%
-703481.4545	1	< 0.1%
3195643.636	1	< 0.1%
-71296971.29	1	< 0.1%
781236417.2	1	< 0.1%
-44647550.16	1	< 0.1%
-88894722.33	1	< 0.1%
313199066.5	1	< 0.1%
11331673.52	1	< 0.1%
2728711.429	1	< 0.1%
Other values (3249)	3249	23.9%
(Missing)	10235	75.2%

Minimum 5 values

Value	Count	Frequency (%)
-5.988427975e+10	1	< 0.1%
-5.798337541e+10	1	< 0.1%
-4.68623551e+10	1	< 0.1%
-1.311579666e+10	1	< 0.1%
-1.310427327e+10	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
3.274134179e+10	1	< 0.1%
3.05322242e+10	1	< 0.1%
2.379214094e+10	1	< 0.1%
1.792668322e+10	1	< 0.1%
1.777537086e+10	1	< 0.1%

loan_vs_6m
Highly correlated

This variable is highly correlated with loan_vs_3m and should be ignored for analysis

Correlation	0.9634403754

LoanBalance
Highly correlated

This variable is highly correlated with avg_loan_3m and should be ignored for analysis

Correlation	0.9520490662

main_account
Categorical, Unique

First 5 values
0001898ab3584ff6a99ec11ffcb1f09c
00029e5f2da54460a1d7dd1a491d991f
00057207ba05405a911387bbcb3861bc
000a64c8a9d5465eba885a561e1b0ca9
001d09340ebb4b95af55684d8635a819

Last 5 values
ffe8f9741d61422eac913ca1fce1c95f
ffef4d87ab1f4afc96255d56b1eec790
fff283aac89f4f82ab8b931dd9a9e41e
fff942970c8d4976993aa8e949f2c228
fff95069a1554792bfe041e2f7b184bc

Toggle details

First 5 values

Value	Count	Frequency (%)
0001898ab3584ff6a99ec11ffcb1f09c	1	< 0.1%
00029e5f2da54460a1d7dd1a491d991f	1	< 0.1%
00057207ba05405a911387bbcb3861bc	1	< 0.1%
000a64c8a9d5465eba885a561e1b0ca9	1	< 0.1%
001d09340ebb4b95af55684d8635a819	1	< 0.1%

Last 5 values

Value	Count	Frequency (%)
fff95069a1554792bfe041e2f7b184bc	1	< 0.1%
fff942970c8d4976993aa8e949f2c228	1	< 0.1%
fff283aac89f4f82ab8b931dd9a9e41e	1	< 0.1%
ffef4d87ab1f4afc96255d56b1eec790	1	< 0.1%
ffe8f9741d61422eac913ca1fce1c95f	1	< 0.1%

num_oder
Numeric

Distinct count	14
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.3024845634
Minimum	0
Maximum	27
Zeros (%)	83.7%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	2
Maximum	27
Range	27
Interquartile range	0

Descriptive statistics

Standard deviation	0.9132913055
Coef of variation	3.019298887
Kurtosis	79.3953906
Mean	0.3024845634
MAD	0.5062903196
Skewness	6.025545905
Sum	4115
Variance	0.8341010087
Memory size	106.4 KiB

Histogram with fixed size bins (bins=14)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 4.5 6.5 8.5 11.5 27. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	11385	83.7%
1	1287	9.5%
2	483	3.6%
3	223	1.6%
4	107	0.8%
5	53	0.4%
6	29	0.2%
7	13	0.1%
8	12	0.1%
10	4	< 0.1%
Other values (4)	8	0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	11385	83.7%
1	1287	9.5%
2	483	3.6%
3	223	1.6%
4	107	0.8%

Maximum 5 values

Value	Count	Frequency (%)
27	1	< 0.1%
12	1	< 0.1%
11	3	< 0.1%
10	4	< 0.1%
9	3	< 0.1%

port_value_vs_1m
Numeric

Distinct count	11790
Unique (%)	86.7%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	144910865.6
Minimum	-9.830860829e+10
Maximum	3.706249945e+11
Zeros (%)	2.4%

Toggle details

Quantile statistics

Minimum	-9.830860829e+10
5-th percentile	-60083345
Q1	-160367.5
Median	16442.5
Q3	6195187.5
95-th percentile	182180999.7
Maximum	3.706249945e+11
Range	4.689336028e+11
Interquartile range	6355555

Descriptive statistics

Standard deviation	4228565006
Coef of variation	29.18045509
Kurtosis	4542.084143
Mean	144910865.6
MAD	337269872.7
Skewness	56.33449157
Sum	1.971367416e+12
Variance	1.788076201e+19
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[-9.83086083e+10 -1.36701909e+10 -3.03975542e+09 -1.01124500e+09 -5.84066938e+08 ... 2.21790195e+09 5.37080886e+09 1.82610628e+10 1.04580500e+11 3.70624994e+11], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	333	2.4%
15275	67	0.5%
9400	49	0.4%
3525	45	0.3%
2350	42	0.3%
1335	34	0.2%
8225	33	0.2%
12925	32	0.2%
-12765	31	0.2%
19333450	25	0.2%
Other values (11780)	12913	94.9%

Minimum 5 values

Value	Count	Frequency (%)
-9.830860829e+10	1	< 0.1%
-3.097203787e+10	1	< 0.1%
-2.848382964e+10	1	< 0.1%
-1.856616175e+10	1	< 0.1%
-1.40365349e+10	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
3.706249945e+11	1	< 0.1%
1.335317752e+11	1	< 0.1%
1.1178384e+11	1	< 0.1%
9.737715978e+10	1	< 0.1%
9.70063935e+10	1	< 0.1%

port_value_vs_3m
Numeric

Distinct count	12348
Unique (%)	90.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	160652168.3
Minimum	-8.38775852e+11
Maximum	8.72527666e+11
Zeros (%)	1.9%

Toggle details

Quantile statistics

Minimum	-8.38775852e+11
5-th percentile	-126889800.1
Q1	-1357746.154
Median	4624.230769
Q3	10598760.38
95-th percentile	317715156.2
Maximum	8.72527666e+11
Range	1.711303518e+12
Interquartile range	11956506.54

Descriptive statistics

Standard deviation	1.165843025e+10
Coef of variation	72.56939248
Kurtosis	4322.562871
Mean	160652168.3
MAD	621804649.2
Skewness	5.499470041
Sum	2.185512097e+12
Variance	1.359189959e+20
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[-8.38775852e+11 -8.42141999e+10 -1.43699935e+10 -2.91842229e+09 -1.62137529e+09 ... 5.53204607e+09 1.40782227e+10 4.14074431e+10 2.34639939e+11 8.72527666e+11], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	257	1.9%
29210	67	0.5%
17975.38462	45	0.3%
6740.769231	43	0.3%
4493.846154	38	0.3%
-950.7692308	34	0.2%
15728.46154	32	0.2%
24716.15385	32	0.2%
-3221.538462	31	0.2%
36970872.31	25	0.2%
Other values (12338)	13000	95.6%

Minimum 5 values

Value	Count	Frequency (%)
-8.38775852e+11	1	< 0.1%
-1.794365538e+11	1	< 0.1%
-8.827642019e+10	1	< 0.1%
-8.01519796e+10	1	< 0.1%
-7.716681874e+10	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
8.72527666e+11	1	< 0.1%
2.5534947e+11	1	< 0.1%
2.139304086e+11	1	< 0.1%
1.8775431e+11	1	< 0.1%
1.874648158e+11	1	< 0.1%

port_value_vs_6m
Highly correlated

This variable is highly correlated with port_value_vs_3m and should be ignored for analysis

Correlation	0.9076132457

portfolio_value
Highly correlated

This variable is highly correlated with avg_portfolio_value_6m and should be ignored for analysis

Correlation	0.9673778626

profit
Numeric

Distinct count	1007
Unique (%)	7.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	117809.4624
Minimum	-349347980
Maximum	615615000
Zeros (%)	91.5%

Toggle details

Quantile statistics

Minimum	-349347980
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	615615000
Range	964962980
Interquartile range	0

Descriptive statistics

Standard deviation	9863835.39
Coef of variation	83.72702152
Kurtosis	1946.161602
Mean	117809.4624
MAD	763559.9918
Skewness	25.84513152
Sum	1602679926
Variance	9.729524861e+13
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[-3.4934798e+08 -1.2010400e+08 -3.9120765e+07 -1.4703250e+07 -6.7050000e+06 ... 9.2650900e+06 1.7068000e+07 5.7881750e+07 2.0793996e+08 6.1561500e+08], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	12447	91.5%
250000	7	0.1%
60000	5	< 0.1%
-80000	5	< 0.1%
-1200000	4	< 0.1%
-200000	4	< 0.1%
360000	4	< 0.1%
50000	4	< 0.1%
800000	4	< 0.1%
-30000	4	< 0.1%
Other values (997)	1116	8.2%

Minimum 5 values

Value	Count	Frequency (%)
-349347980	1	< 0.1%
-318174550	1	< 0.1%
-127228000	1	< 0.1%
-112980000	1	< 0.1%
-102435000	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
615615000	1	< 0.1%
519606400	1	< 0.1%
216000000	1	< 0.1%
199879920	1	< 0.1%
194221500	1	< 0.1%

profit_1m
Numeric

Distinct count	4275
Unique (%)	31.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	-4321903.938
Minimum	-1.710295648e+10
Maximum	1.658551664e+10
Zeros (%)	65.4%

Toggle details

Quantile statistics

Minimum	-1.710295648e+10
5-th percentile	-20455944.5
Q1	0
Median	0
Q3	0
95-th percentile	4620706.25
Maximum	1.658551664e+10
Range	3.368847312e+10
Interquartile range	0

Descriptive statistics

Standard deviation	228883856.7
Coef of variation	-52.95903379
Kurtosis	4366.427447
Mean	-4321903.938
MAD	16537083.04
Skewness	-3.018362292
Sum	-5.879518117e+10
Variance	5.238781985e+16
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[-1.71029565e+10 -2.14753600e+09 -9.67038700e+08 -3.45363500e+08 -1.85740115e+08 ... 6.26865400e+07 1.42768320e+08 2.86889650e+08 1.15791714e+09 1.65855166e+10], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	8893	65.4%
50000	10	0.1%
-200000	8	0.1%
6000	7	0.1%
100000	7	0.1%
-900000	6	< 0.1%
-300000	6	< 0.1%
-3500000	6	< 0.1%
-170000	6	< 0.1%
-350000	6	< 0.1%
Other values (4265)	4649	34.2%

Minimum 5 values

Value	Count	Frequency (%)
-1.710295648e+10	1	< 0.1%
-4795443160	1	< 0.1%
-4101002000	1	< 0.1%
-2265000000	1	< 0.1%
-2030072000	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1.658551664e+10	1	< 0.1%
5395040000	1	< 0.1%
2401551060	1	< 0.1%
1712923410	1	< 0.1%
1589843720	1	< 0.1%

profit_3m
Numeric

Distinct count	5926
Unique (%)	43.6%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	36171208.98
Minimum	-1.5608975e+10
Maximum	5.394120453e+11
Zeros (%)	53.8%

Toggle details

Quantile statistics

Minimum	-1.5608975e+10
5-th percentile	-46098213
Q1	-16825
Median	0
Q3	0
95-th percentile	20831631
Maximum	5.394120453e+11
Range	5.550210203e+11
Interquartile range	16825

Descriptive statistics

Standard deviation	4638865111
Coef of variation	128.2474443
Kurtosis	13439.42418
Mean	36171208.98
MAD	102259660.2
Skewness	115.58013
Sum	4.92073127e+11
Variance	2.151906951e+19
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[-1.56089750e+10 -4.70445215e+09 -1.41114450e+09 -6.96623830e+08 -3.96705865e+08 ... 3.01177850e+08 6.07549115e+08 3.55592540e+09 1.65007302e+10 5.39412045e+11], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	7316	53.8%
-100000	8	0.1%
150000	8	0.1%
200000	6	< 0.1%
800000	6	< 0.1%
-200000	6	< 0.1%
-40000	6	< 0.1%
100000	5	< 0.1%
50000	5	< 0.1%
300000	5	< 0.1%
Other values (5916)	6233	45.8%

Minimum 5 values

Value	Count	Frequency (%)
-1.5608975e+10	1	< 0.1%
-1.362708333e+10	1	< 0.1%
-1.12361121e+10	1	< 0.1%
-4950650000	1	< 0.1%
-4458254300	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
5.394120453e+11	1	< 0.1%
1.772901048e+10	1	< 0.1%
1.527245e+10	1	< 0.1%
1.51568364e+10	1	< 0.1%
8133764640	1	< 0.1%

profit_6m
Highly correlated

This variable is highly correlated with profit_3m and should be ignored for analysis

Correlation	0.9943629294

profit_per
Numeric

Distinct count	1057
Unique (%)	7.8%
Missing (%)	91.4%
Missing (n)	12437
Infinite (%)	0.0%
Infinite (n)	0

Mean	-0.006972851696
Minimum	-0.932
Maximum	0.5087719298
Zeros (%)	0.1%

Toggle details

Quantile statistics

Minimum	-0.932
5-th percentile	-0.1493567382
Q1	-0.03215310904
Median	0
Q3	0.0295031947
95-th percentile	0.1012985049
Maximum	0.5087719298
Range	1.44077193
Interquartile range	0.06165630375

Descriptive statistics

Standard deviation	0.0884352132
Coef of variation	-12.68278992
Kurtosis	16.25935014
Mean	-0.006972851696
MAD	0.05380847175
Skewness	-1.298429184
Sum	-8.137317929
Variance	0.007820786933
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10	0.1%
0.02610759494	10	0.1%
-0.02071005917	10	0.1%
-0.0313253012	8	0.1%
0.03202846975	6	< 0.1%
0.0623556582	6	< 0.1%
-0.0293255132	6	< 0.1%
0.1052631579	4	< 0.1%
0.02206461781	4	< 0.1%
0.03401360544	3	< 0.1%
Other values (1046)	1100	8.1%
(Missing)	12437	91.4%

Minimum 5 values

Value	Count	Frequency (%)
-0.932	1	< 0.1%
-0.5227068664	1	< 0.1%
-0.5188764514	1	< 0.1%
-0.4219979136	1	< 0.1%
-0.4193548387	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
0.5087719298	1	< 0.1%
0.4194101225	1	< 0.1%
0.3996586198	1	< 0.1%
0.3930348259	1	< 0.1%
0.3898641614	1	< 0.1%

region
Categorical

Distinct count	71
Unique (%)	0.5%
Missing (%)	0.0%
Missing (n)	0

HN	3940
DVSN	3385
HCM	1995
Other values (68)	4284

Toggle details

Common values
Composition

Value	Count	Frequency (%)
HN	3940	29.0%
DVSN	3385	24.9%
HCM	1995	14.7%
NgheAn	246	1.8%
DaNang	195	1.4%
ThanhHoa	193	1.4%
DongNai	187	1.4%
NamDinh	168	1.2%
BacNinh	158	1.2%
HaiPhong	148	1.1%
Other values (61)	2989	22.0%

Max length	10
Mean length	4.250882094
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

sell_order
Numeric

Distinct count	11
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.1234930903
Minimum	0
Maximum	18
Zeros (%)	91.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	1
Maximum	18
Range	18
Interquartile range	0

Descriptive statistics

Standard deviation	0.5023309343
Coef of variation	4.067684542
Kurtosis	162.5919919
Mean	0.1234930903
MAD	0.2257988185
Skewness	8.550222405
Sum	1680
Variance	0.2523363676
Memory size	106.4 KiB

Histogram with fixed size bins (bins=11)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 4.5 8.5 18. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	12437	91.4%
1	856	6.3%
2	202	1.5%
3	64	0.5%
4	28	0.2%
5	8	0.1%
7	3	< 0.1%
6	2	< 0.1%
8	2	< 0.1%
18	1	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	12437	91.4%
1	856	6.3%
2	202	1.5%
3	64	0.5%
4	28	0.2%

Maximum 5 values

Value	Count	Frequency (%)
18	1	< 0.1%
9	1	< 0.1%
8	2	< 0.1%
7	3	< 0.1%
6	2	< 0.1%

sell_order_1m
Numeric

Distinct count	71
Unique (%)	0.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.139223758
Minimum	0
Maximum	199
Zeros (%)	65.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	2
95-th percentile	11
Maximum	199
Range	199
Interquartile range	2

Descriptive statistics

Standard deviation	6.141631988
Coef of variation	2.870962874
Kurtosis	165.7239961
Mean	2.139223758
MAD	2.999617915
Skewness	9.172206545
Sum	29102
Variance	37.71964348
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 26.5 33.5 50. 85. 199. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	8865	65.2%
1	1167	8.6%
2	788	5.8%
3	531	3.9%
4	376	2.8%
5	293	2.2%
6	259	1.9%
7	192	1.4%
8	157	1.2%
9	141	1.0%
Other values (61)	835	6.1%

Minimum 5 values

Value	Count	Frequency (%)
0	8865	65.2%
1	1167	8.6%
2	788	5.8%
3	531	3.9%
4	376	2.8%

Maximum 5 values

Value	Count	Frequency (%)
199	1	< 0.1%
157	1	< 0.1%
125	1	< 0.1%
115	1	< 0.1%
103	1	< 0.1%

sell_order_3m
Highly correlated

This variable is highly correlated with sell_order_1m and should be ignored for analysis

Correlation	0.9065289845

sell_order_6m
Highly correlated

This variable is highly correlated with sell_order_3m and should be ignored for analysis

Correlation	0.9577278331

sell_order_gain
Numeric

Distinct count	7
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.06093795942
Minimum	0
Maximum	7
Zeros (%)	95.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	7
Range	7
Interquartile range	0

Descriptive statistics

Standard deviation	0.3065702678
Coef of variation	5.030858773
Kurtosis	77.7788638
Mean	0.06093795942
MAD	0.1159630913
Skewness	7.267902874
Sum	829
Variance	0.09398532909
Memory size	106.4 KiB

Histogram with fixed size bins (bins=7)

Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 7. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	12944	95.1%
1	542	4.0%
2	86	0.6%
3	21	0.2%
5	5	< 0.1%
4	5	< 0.1%
7	1	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	12944	95.1%
1	542	4.0%
2	86	0.6%
3	21	0.2%
4	5	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
7	1	< 0.1%
5	5	< 0.1%
4	5	< 0.1%
3	21	0.2%
2	86	0.6%

sell_order_loss
Numeric

Distinct count	8
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.06057042046
Minimum	0
Maximum	11
Zeros (%)	95.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	11
Range	11
Interquartile range	0

Descriptive statistics

Standard deviation	0.3079588229
Coef of variation	5.084310469
Kurtosis	164.8590216
Mean	0.06057042046
MAD	0.1152458662
Skewness	8.923036774
Sum	824
Variance	0.09483863659
Memory size	106.4 KiB

Histogram with fixed size bins (bins=8)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 4.5 11. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	12942	95.1%
1	546	4.0%
2	88	0.6%
3	20	0.1%
4	5	< 0.1%
6	1	< 0.1%
5	1	< 0.1%
11	1	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	12942	95.1%
1	546	4.0%
2	88	0.6%
3	20	0.1%
4	5	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
11	1	< 0.1%
6	1	< 0.1%
5	1	< 0.1%
4	5	< 0.1%
3	20	0.1%

sell_orders_1m_3m_per
Numeric

Distinct count	566
Unique (%)	4.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.701648483
Minimum	0
Maximum	1
Zeros (%)	11.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.3181818182
Median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range	0.6818181818

Descriptive statistics

Standard deviation	0.3928197584
Coef of variation	0.559852644
Kurtosis	-1.177668115
Mean	0.701648483
MAD	0.360876928
Skewness	-0.7428339894
Sum	9545.225963
Variance	0.1543073626
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0. 0.00649351 0.0274024 0.04880952 0.08220721 ... 0.85449735 0.86038961 0.91106719 0.98913043 1. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	8142	59.9%
0	1568	11.5%
0.5	346	2.5%
0.3333333333	295	2.2%
0.25	179	1.3%
0.6666666667	148	1.1%
0.2	130	1.0%
0.1666666667	100	0.7%
0.4	89	0.7%
0.75	81	0.6%
Other values (556)	2526	18.6%

Minimum 5 values

Value	Count	Frequency (%)
0	1568	11.5%
0.01298701299	1	< 0.1%
0.01724137931	1	< 0.1%
0.02702702703	1	< 0.1%
0.02777777778	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1	8142	59.9%
0.9782608696	1	< 0.1%
0.962962963	1	< 0.1%
0.9523809524	1	< 0.1%
0.9375	1	< 0.1%

sell_orders_1m_6m_per
Numeric

Distinct count	785
Unique (%)	5.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.6163211648
Minimum	0
Maximum	1
Zeros (%)	16.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.1363636364
Median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range	0.8636363636

Descriptive statistics

Standard deviation	0.434040184
Coef of variation	0.7042435159
Kurtosis	-1.702532803
Mean	0.6163211648
MAD	0.4155169174
Skewness	-0.3702163563
Sum	8384.433126
Variance	0.1883908813
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0. 0.00362319 0.02150786 0.04706534 0.04808137 ... 0.79473684 0.80384615 0.91106719 0.98913043 1. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	7249	53.3%
0	2299	16.9%
0.5	223	1.6%
0.3333333333	189	1.4%
0.2	166	1.2%
0.25	147	1.1%
0.1666666667	107	0.8%
0.6666666667	106	0.8%
0.1428571429	91	0.7%
0.4	75	0.6%
Other values (775)	2952	21.7%

Minimum 5 values

Value	Count	Frequency (%)
0	2299	16.9%
0.007246376812	1	< 0.1%
0.008064516129	1	< 0.1%
0.01063829787	1	< 0.1%
0.01515151515	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1	7249	53.3%
0.9782608696	1	< 0.1%
0.9701492537	1	< 0.1%
0.962962963	1	< 0.1%
0.9523809524	1	< 0.1%

stock_count
Highly correlated

This variable is highly correlated with avg_stock_count_6m and should be ignored for analysis

Correlation	0.967179082

stock_count_vs_1m
Numeric

Distinct count	21
Unique (%)	0.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.04483975301
Minimum	-28
Maximum	12
Zeros (%)	80.7%

Toggle details

Quantile statistics

Minimum	-28
5-th percentile	-1
Q1	0
Median	0
Q3	0
95-th percentile	1
Maximum	12
Range	40
Interquartile range	0

Descriptive statistics

Standard deviation	0.7989300236
Coef of variation	17.81744925
Kurtosis	136.4729324
Mean	0.04483975301
MAD	0.3180316667
Skewness	-1.760603746
Sum	610
Variance	0.6382891826
Memory size	106.4 KiB

Histogram with fixed size bins (bins=21)

Histogram with variable size bins (bins=[-28. -9.5 -4.5 -3.5 -2.5 ... 2.5 3.5 4.5 6.5 12. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	10985	80.7%
1	965	7.1%
-1	881	6.5%
2	310	2.3%
-2	215	1.6%
3	109	0.8%
-3	52	0.4%
4	31	0.2%
-4	19	0.1%
5	12	0.1%
Other values (11)	25	0.2%

Minimum 5 values

Value	Count	Frequency (%)
-28	1	< 0.1%
-12	1	< 0.1%
-7	2	< 0.1%
-6	1	< 0.1%
-5	3	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
12	1	< 0.1%
10	2	< 0.1%
9	3	< 0.1%
8	2	< 0.1%
7	3	< 0.1%

stock_count_vs_3m
Numeric

Distinct count	29
Unique (%)	0.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.08431343722
Minimum	-26
Maximum	18
Zeros (%)	73.2%

Toggle details

Quantile statistics

Minimum	-26
5-th percentile	-1
Q1	0
Median	0
Q3	0
95-th percentile	2
Maximum	18
Range	44
Interquartile range	0

Descriptive statistics

Standard deviation	1.131645426
Coef of variation	13.42188698
Kurtosis	53.11587262
Mean	0.08431343722
MAD	0.5097561547
Skewness	1.242703551
Sum	1147
Variance	1.280621369
Memory size	106.4 KiB

Histogram with fixed size bins (bins=29)

Histogram with variable size bins (bins=[-26. -7.5 -4.5 -3.5 -2.5 ... 3.5 4.5 6.5 10.5 18. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	9952	73.2%
1	1205	8.9%
-1	1137	8.4%
2	449	3.3%
-2	330	2.4%
3	184	1.4%
-3	100	0.7%
4	80	0.6%
-4	40	0.3%
5	33	0.2%
Other values (19)	94	0.7%

Minimum 5 values

Value	Count	Frequency (%)
-26	1	< 0.1%
-15	1	< 0.1%
-11	1	< 0.1%
-10	2	< 0.1%
-8	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
18	1	< 0.1%
16	1	< 0.1%
15	3	< 0.1%
14	2	< 0.1%
12	1	< 0.1%

stock_count_vs_6m
Highly correlated

This variable is highly correlated with stock_count_vs_3m and should be ignored for analysis

Correlation	0.9005250291

total_buy_order_1m_3m_per
Highly correlated

This variable is highly correlated with buy_orders_1m_3m_per and should be ignored for analysis

Correlation	0.9809048155

total_buy_order_1m_6m_per
Highly correlated

This variable is highly correlated with buy_orders_1m_6m_per and should be ignored for analysis

Correlation	0.9834419742

total_buy_value
Numeric

Distinct count	1372
Unique (%)	10.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	26703523.72
Minimum	0
Maximum	1.7157975e+10
Zeros (%)	88.0%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	48234000
Maximum	1.7157975e+10
Range	1.7157975e+10
Interquartile range	0

Descriptive statistics

Standard deviation	353506456.7
Coef of variation	13.23819509
Kurtosis	1363.955774
Mean	26703523.72
MAD	48974350.09
Skewness	33.59928488
Sum	3.632747368e+11
Variance	1.249668149e+17
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.0000000e+00 1.1325000e+04 2.5525000e+04 1.8340000e+06 7.2710000e+06 ... 3.3131600e+08 7.0250000e+08 1.1606080e+09 3.9513000e+09 1.7157975e+10], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	11966	88.0%
33100000	11	0.1%
18100000	10	0.1%
22650	8	0.1%
99300000	6	< 0.1%
165500000	5	< 0.1%
19700000	5	< 0.1%
1810000	5	< 0.1%
16550000	5	< 0.1%
138033000	4	< 0.1%
Other values (1362)	1579	11.6%

Minimum 5 values

Value	Count	Frequency (%)
0	11966	88.0%
22650	8	0.1%
28400	1	< 0.1%
47000	1	< 0.1%
62400	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1.7157975e+10	1	< 0.1%
1.624e+10	1	< 0.1%
1.518003e+10	1	< 0.1%
1.46419113e+10	1	< 0.1%
1.10079e+10	1	< 0.1%

total_buy_value_1m
Numeric

Distinct count	5410
Unique (%)	39.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	433664573.2
Minimum	0
Maximum	1.517087434e+12
Zeros (%)	58.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	58715000
95-th percentile	1068707642
Maximum	1.517087434e+12
Range	1.517087434e+12
Interquartile range	58715000

Descriptive statistics

Standard deviation	1.320953789e+10
Coef of variation	30.46026515
Kurtosis	12778.54024
Mean	433664573.2
MAD	719720634.7
Skewness	111.4168123
Sum	5.899572854e+12
Variance	1.744918912e+20
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e+02 2.45100000e+05 1.27727500e+06 4.99900000e+06 ... 6.72177500e+09 1.75780045e+10 3.25116998e+10 5.78454355e+10 1.51708743e+12], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	7920	58.2%
3590000	8	0.1%
1795000	7	0.1%
135529000	6	< 0.1%
8975000	6	< 0.1%
7180000	6	< 0.1%
89750	5	< 0.1%
22650	5	< 0.1%
110470500	4	< 0.1%
138033000	4	< 0.1%
Other values (5400)	5633	41.4%

Minimum 5 values

Value	Count	Frequency (%)
0	7920	58.2%
1000	1	< 0.1%
4200	3	< 0.1%
6000	1	< 0.1%
8400	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1.517087434e+12	1	< 0.1%
1.22e+11	1	< 0.1%
1.012085485e+11	1	< 0.1%
6.4949831e+10	1	< 0.1%
5.074104e+10	1	< 0.1%

total_buy_value_3m
Highly correlated

This variable is highly correlated with total_buy_value_1m and should be ignored for analysis

Correlation	0.9484353291

total_buy_value_6m
Numeric

Distinct count	8335
Unique (%)	61.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2441528103
Minimum	0
Maximum	6.754880554e+12
Zeros (%)	35.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	19349650
Q3	455675125
95-th percentile	6268552400
Maximum	6.754880554e+12
Range	6.754880554e+12
Interquartile range	455675125

Descriptive statistics

Standard deviation	6.149979756e+10
Coef of variation	25.18905987
Kurtosis	10758.92576
Mean	2441528103
MAD	3967073178
Skewness	99.82045008
Sum	3.321454831e+13
Variance	3.7822251e+21
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000000e+00 2.10000000e+03 2.17500000e+04 2.35000000e+04 2.37000000e+04 ... 4.69836855e+10 8.59139626e+10 1.81239734e+11 5.66247875e+11 6.75488055e+12], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	4822	35.4%
233200	32	0.2%
44650	13	0.1%
23600	12	0.1%
111000	11	0.1%
22200	11	0.1%
44400	8	0.1%
445200	7	0.1%
310800	7	0.1%
88800	6	< 0.1%
Other values (8325)	8675	63.8%

Minimum 5 values

Value	Count	Frequency (%)
0	4822	35.4%
4200	3	< 0.1%
6800	1	< 0.1%
7000	1	< 0.1%
7500	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
6.754880554e+12	1	< 0.1%
1.936789406e+12	1	< 0.1%
6.93925e+11	1	< 0.1%
4.3857075e+11	1	< 0.1%
3.967535841e+11	1	< 0.1%

total_sell_order_1m_3m_per
Highly correlated

This variable is highly correlated with sell_orders_1m_3m_per and should be ignored for analysis

Correlation	0.9806879469

total_sell_order_1m_6m_per
Highly correlated

This variable is highly correlated with sell_orders_1m_6m_per and should be ignored for analysis

Correlation	0.9863198197

total_sell_value
Numeric

Distinct count	1025
Unique (%)	7.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	14129442.43
Minimum	0
Maximum	1.003275e+10
Zeros (%)	91.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	23302000
Maximum	1.003275e+10
Range	1.003275e+10
Interquartile range	0

Descriptive statistics

Standard deviation	156766338.6
Coef of variation	11.09501237
Kurtosis	1577.836066
Mean	14129442.43
MAD	26325774.17
Skewness	32.59792884
Sum	1.922169348e+11
Variance	2.457568491e+16
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.0000000e+00 1.6250000e+04 2.5920000e+06 1.1492500e+07 2.4294000e+07 ... 3.0236900e+08 6.9981125e+08 1.5701045e+09 2.7568400e+09 1.0032750e+10], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	12437	91.4%
16550000	6	< 0.1%
66200000	5	< 0.1%
18100000	5	< 0.1%
1150000	4	< 0.1%
40200000	4	< 0.1%
3620000	4	< 0.1%
33600000	4	< 0.1%
160800000	4	< 0.1%
2560000	4	< 0.1%
Other values (1015)	1127	8.3%

Minimum 5 values

Value	Count	Frequency (%)
0	12437	91.4%
32500	2	< 0.1%
62400	1	< 0.1%
68000	1	< 0.1%
69200	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1.003275e+10	1	< 0.1%
5896074000	1	< 0.1%
5009760000	1	< 0.1%
4256250000	1	< 0.1%
3801000000	1	< 0.1%

total_sell_value_1m
Numeric

Distinct count	4552
Unique (%)	33.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	283727916.1
Minimum	0
Maximum	3.91607438e+11
Zeros (%)	65.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	29303250
95-th percentile	833674250
Maximum	3.91607438e+11
Range	3.91607438e+11
Interquartile range	29303250

Descriptive statistics

Standard deviation	3943894189
Coef of variation	13.90026841
Kurtosis	7223.185984
Mean	283727916.1
MAD	471326025.3
Skewness	76.04338338
Sum	3.859834571e+12
Variance	1.555430137e+19
Memory size	106.4 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e+02 1.32170000e+06 6.62450000e+06 2.23710000e+07 ... 6.91127410e+09 1.26510986e+10 3.15418694e+10 7.14086750e+10 3.91607438e+11], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	8867	65.2%
20700000	5	< 0.1%
19500000	5	< 0.1%
72000000	4	< 0.1%
1150000	4	< 0.1%
14400000	4	< 0.1%
28800000	4	< 0.1%
11300000	4	< 0.1%
67400000	3	< 0.1%
46600000	3	< 0.1%
Other values (4542)	4701	34.6%

Minimum 5 values

Value	Count	Frequency (%)
0	8867	65.2%
1000	1	< 0.1%
5500	1	< 0.1%
11000	1	< 0.1%
13500	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
3.91607438e+11	1	< 0.1%
1.24290072e+11	1	< 0.1%
7.257735e+10	1	< 0.1%
7.024e+10	1	< 0.1%
5.5169364e+10	1	< 0.1%

total_sell_value_3m
Highly correlated

This variable is highly correlated with profit_6m and should be ignored for analysis

Correlation	0.9617840254

total_sell_value_6m
Highly correlated

This variable is highly correlated with total_sell_value_3m and should be ignored for analysis

Correlation	0.988218788

trading_date
Constant

This variable is constant and should be ignored for analysis

Constant value	2019-09-30

trading_month
Constant

This variable is constant and should be ignored for analysis

Constant value	9

First rows

	Age	avg_cash_1m	avg_cash_3m	avg_cash_6m	avg_loan_1m	avg_loan_3m	avg_loan_6m	avg_portfolio_value_1m	avg_portfolio_value_3m	avg_portfolio_value_6m	avg_profit_per_6m	avg_stock_count_1m	avg_stock_count_3m	avg_stock_count_6m	buy_order_1m	buy_order_3m	buy_order_6m	buy_orders_1m_3m_per	buy_orders_1m_6m_per	cash_vs_1m	cash_vs_3m	cash_vs_6m	CashBalance	Gender	loan_vs_1m	loan_vs_3m	loan_vs_6m	LoanBalance	main_account	port_value_vs_1m	port_value_vs_3m	port_value_vs_6m	portfolio_value	profit_1m	profit_3m	profit_6m	profit_per	region	sell_order_1m	sell_order_3m	sell_order_6m	sell_orders_1m_3m_per	sell_orders_1m_6m_per	stock_count	stock_count_vs_1m	stock_count_vs_3m	stock_count_vs_6m	total_buy_order_1m_3m_per	total_buy_order_1m_6m_per	total_buy_value_1m	total_buy_value_3m	total_buy_value_6m	total_sell_order_1m_3m_per	total_sell_order_1m_6m_per	total_sell_value_1m	total_sell_value_3m	total_sell_value_6m	trading_date	trading_month
0	56	1764517.70	2208024.38	1761109.13	nan	nan	nan	75117895.50	77020380.77	79136573.89	1.61	9.85	9.26	9.13	1	2	2	0.50	0.50	-1346537.70	-1790044.38	-1343129.13	417980.00	F	nan	nan	nan	nan	0001898ab3584ff6a99ec11ffcb1f09c	927824.50	-974660.77	-3090853.89	76045720.00	0	-1516300	-1516300	nan	HN	0	2	2	0.00	0.00	10	0.00	1.00	1.00	0.93	0.93	9248000	9909200	9909200	0.00	0.00	0	8442000	8442000	2019-09-30	9
1	31	1303094.80	403252.05	209998.61	35050012.79	123084390.94	153996251.28	45792700.00	170618307.69	217354130.95	-0.08	3.85	3.95	3.92	3	5	11	0.60	0.27	-1150239.80	-250397.05	-57143.61	152855.00	F	-23571153.79	-111605531.94	-142517392.28	11478859.00	00029e5f2da54460a1d7dd1a491d991f	-15452700.00	-140278307.69	-187014130.95	30340000.00	-63556460	-82279590	-83728490	nan	HN	4	6	9	0.67	0.44	4	0.00	0.00	0.00	0.56	0.13	76320000	136390000	576362500	0.74	0.28	225433000	303288500	809958500	2019-09-30	9
2	37	23146.00	23143.91	23141.06	nan	nan	nan	61965.00	64250.77	67576.19	nan	1.00	1.00	1.00	0	0	0	1.00	1.00	0.00	2.09	4.94	23146.00	M	nan	nan	nan	nan	00057207ba05405a911387bbcb3861bc	1335.00	-950.77	-4276.19	63300.00	0	0	0	nan	ThanhHoa	0	0	0	1.00	1.00	1	0.00	0.00	0.00	1.00	1.00	0	0	0	1.00	1.00	0	0	0	2019-09-30	9
3	64	54536987.10	40602026.75	22396767.01	nan	nan	nan	319849589.00	338784400.31	351875873.41	0.14	19.65	20.94	21.39	3	34	57	0.09	0.05	-22570.10	13912390.25	32117649.99	54514417.00	M	nan	nan	nan	nan	000a64c8a9d5465eba885a561e1b0ca9	3833991.00	-15100820.31	-28192293.41	323683580.00	-157750	11723760	14026060	nan	DVSN	3	42	48	0.07	0.06	19	-1.00	-2.00	-2.00	0.10	0.06	7681000	79384500	126329600	0.06	0.05	7538000	122955700	140665700	2019-09-30	9
4	40	7768366.45	6756040.66	5297377.99	77494639.00	158683067.50	204127222.77	89628850.00	211257232.31	313340330.16	-0.11	1.95	3.02	3.94	1	4	12	0.25	0.08	11562148.55	12574474.34	14033137.01	19330515.00	F	nan	nan	nan	nan	001d09340ebb4b95af55684d8635a819	-48591100.00	-170219482.31	-272302580.16	41037750.00	-21800000	-22202500	-46487500	nan	DVSN	1	10	16	0.10	0.06	2	0.00	-1.00	-2.00	0.01	0.00	3320750	248180750	769080750	0.12	0.10	91600000	758416100	882576100	2019-09-30	9
5	55	18813004.40	14705520.20	14705520.20	nan	nan	nan	69927750.00	71070666.67	71070666.67	-0.08	3.65	2.98	2.98	2	5	5	0.40	0.40	9349654.60	13457138.80	13457138.80	28162659.00	M	nan	nan	nan	nan	0023387d6b544f53a9306495d5576cae	-11117750.00	-12260666.67	-12260666.67	58810000.00	-5370000	-6270000	-6270000	nan	HCM	2	3	3	0.67	0.67	3	-1.00	0.00	0.00	0.26	0.26	33600000	131365000	131365000	0.74	0.74	45360000	61060000	61060000	2019-09-30	9
6	35	3391323.00	3388776.34	3386420.26	222707013.35	200418954.92	182619916.76	363438520.00	340078321.54	319609795.24	-0.17	3.85	3.75	3.87	3	5	7	0.60	0.43	0.00	2546.66	4902.74	3391323.00	M	-7095702.35	15192356.08	32991394.24	215611311.00	00237505b9d5473186b894283286e3a7	-1436220.00	21923978.46	42392504.76	362002300.00	-29790000	-36869640	-44580480	nan	BacNinh	1	6	10	0.17	0.10	4	0.00	0.00	0.00	0.38	0.32	102496000	269820000	323618000	0.81	0.69	162000000	201084500	233894000	2019-09-30	9
7	31	275.00	179100.42	2863666.17	1274397504.10	1285594458.35	1975358069.89	2007607000.00	1646555750.00	2552118421.57	-0.00	1.90	2.24	1.88	5	22	51	0.23	0.10	0.00	-178825.42	-2863391.17	275.00	M	-42361841.10	-53558795.35	-743322406.89	1232035663.00	0029fdde7ec841dbbf3c5166b50ed76d	24925000.00	385976250.00	-519586421.57	2032532000.00	-12580000	-2008020	-104984230	nan	HCM	2	16	33	0.12	0.06	1	-1.00	-1.00	-1.00	0.09	0.02	502000000	5324570500	22525454500	0.07	0.03	555920000	7699907500	20326589000	2019-09-30	9
8	35	8050577.00	8871833.23	6652609.92	nan	nan	nan	244466550.00	270283135.38	274946692.30	0.24	7.00	7.48	7.75	1	5	11	0.20	0.09	-7864875.00	-8686131.23	-6466907.92	185702.00	M	nan	nan	nan	nan	002c1a2e3c054378b7261e680f19b5c4	774450.00	-25042135.38	-29705692.30	245241000.00	0	16694500	16721709	nan	HCM	0	3	7	0.00	0.00	7	0.00	0.00	-1.00	0.07	0.05	2610000	35910000	52730000	0.00	0.00	0	71080000	71533510	2019-09-30	9
9	35	88179.00	88549.34	89045.14	nan	nan	nan	2515660.00	2212118.46	1989566.67	nan	1.00	1.00	1.00	0	0	0	1.00	1.00	0.00	-370.34	-866.14	88179.00	M	nan	nan	nan	nan	002c9f8d8f9842b9959f3f52bcc3b5be	233240.00	536781.54	759333.33	2748900.00	0	0	0	nan	BacNinh	0	0	0	1.00	1.00	1	0.00	0.00	0.00	1.00	1.00	0	0	0	1.00	1.00	0	0	0	2019-09-30	9

Last rows

	Age	avg_cash_1m	avg_cash_3m	avg_cash_6m	avg_loan_1m	avg_loan_3m	avg_loan_6m	avg_portfolio_value_1m	avg_portfolio_value_3m	avg_portfolio_value_6m	avg_profit_per_6m	avg_stock_count_1m	avg_stock_count_3m	avg_stock_count_6m	buy_order_1m	buy_order_3m	buy_order_6m	buy_orders_1m_3m_per	buy_orders_1m_6m_per	cash_vs_1m	cash_vs_3m	cash_vs_6m	CashBalance	Gender	loan_vs_1m	loan_vs_3m	loan_vs_6m	LoanBalance	main_account	num_oder	port_value_vs_1m	port_value_vs_3m	port_value_vs_6m	portfolio_value	profit	profit_1m	profit_3m	profit_6m	profit_per	region	sell_order	sell_order_1m	sell_order_3m	sell_order_6m	sell_order_loss	sell_orders_1m_3m_per	sell_orders_1m_6m_per	stock_count	stock_count_vs_1m	stock_count_vs_3m	stock_count_vs_6m	total_buy_order_1m_3m_per	total_buy_order_1m_6m_per	total_buy_value_1m	total_buy_value_3m	total_buy_value_6m	total_sell_order_1m_3m_per	total_sell_order_1m_6m_per	total_sell_value	total_sell_value_1m	total_sell_value_3m	total_sell_value_6m	trading_date	trading_month
13594	32	1582745.00	1922349.22	1995344.72	nan	nan	68307961.46	34596000.00	36012923.08	55203634.92	-0.04	1.00	1.00	1.10	0	0	7	1.00	0.00	-25550.00	-365154.22	-438149.72	1557195.00	M	nan	nan	nan	nan	ffcfd3ca703a4b898dd7e84608c24ac2	0	-996000.00	-2412923.08	-21603634.92	33600000.00	0	0	0	-7750000	nan	BinhDinh	0	0	0	3	0	1.00	0.00	1	0.00	0.00	0.00	1.00	0.00	0	0	85442000	1.00	0.00	0	0	0	175300000	2019-09-30	9
13595	51	458492.00	453035.09	448177.23	nan	nan	nan	268360.00	288443.08	296463.49	nan	1.00	1.00	1.00	0	0	0	1.00	1.00	0.00	5456.91	10314.77	458492.00	M	nan	nan	nan	nan	ffd2140f5c4e49da9179c45e7e38c3d4	0	-360.00	-20443.08	-28463.49	268000.00	0	0	0	0	nan	HCM	0	0	0	0	0	1.00	1.00	1	0.00	0.00	0.00	1.00	1.00	0	0	0	1.00	1.00	0	0	0	0	2019-09-30	9
13596	47	nan	nan	nan	nan	nan	nan	343477250.00	325839827.69	318587310.32	nan	1.00	1.00	1.00	0	0	0	1.00	1.00	nan	nan	nan	nan	M	nan	nan	nan	nan	ffd57e6c45134224b6c81ca14fd47ec1	0	19333450.00	36970872.31	44223389.68	362810700.00	0	0	0	0	nan	HCM	0	0	0	0	0	1.00	1.00	1	0.00	0.00	0.00	1.00	1.00	0	0	0	1.00	1.00	0	0	0	0	2019-09-30	9
13597	26	19.00	383.15	382968.93	86461940.50	209378665.69	303947833.91	377500000.00	516860000.00	585950793.65	-0.04	1.00	1.18	1.38	0	0	4	1.00	0.00	0.00	-364.15	-382949.93	19.00	M	-66134.50	-122982859.69	-217552027.91	86395806.00	ffdf95af414245f285c0ec4e91965595	0	2500000.00	-136860000.00	-205950793.65	380000000.00	0	0	-39370000	-35630000	nan	ThaiBinh	0	0	3	4	0	0.00	0.00	1	0.00	0.00	0.00	1.00	0.00	0	0	627860000	0.00	0.00	0	0	416400000	469200000	2019-09-30	9
13598	41	41875.00	4726119.31	2443819.16	nan	nan	nan	229625.00	217833.85	212985.32	nan	1.00	1.00	1.00	0	0	0	1.00	1.00	0.00	-4684244.31	-2401944.16	41875.00	F	nan	nan	nan	nan	ffdfbcad4f2340f78012055b4c59f3ef	0	12925.00	24716.15	29564.68	242550.00	0	0	0	0	nan	DVSN	0	0	0	0	0	1.00	1.00	1	0.00	0.00	0.00	1.00	1.00	0	0	0	1.00	1.00	0	0	0	0	2019-09-30	9
13599	56	11985.00	15096199.74	21149290.36	180696692.00	151900093.20	126343114.11	334997500.00	318949630.77	291121111.11	-0.06	2.00	2.09	2.06	0	2	6	0.00	0.00	0.00	-15084214.74	-21137305.36	11985.00	F	-1282500.00	27514098.80	53071077.89	179414192.00	ffe8f9741d61422eac913ca1fce1c95f	0	-447500.00	15600369.23	43428888.89	334550000.00	0	0	-42424000	-36674000	nan	DVSN	0	0	3	5	0	0.00	0.00	2	0.00	0.00	0.00	0.00	0.00	0	418900000	1055525000	0.00	0.00	0	0	364451000	720951000	2019-09-30	9
13600	36	152426.00	91283.35	53303.34	157685875.79	137145635.25	140967703.35	185371550.00	154879649.23	149589155.00	0.01	2.95	3.03	3.23	10	49	100	0.20	0.10	1496075.00	1557217.65	1595197.66	1648501.00	M	nan	nan	nan	nan	ffef4d87ab1f4afc96255d56b1eec790	1	-185371550.00	-154879649.23	-149589155.00	0.00	-2283400	-1465670	7825940	19404240	-0.03	DVSN	1	12	42	80	1	0.29	0.15	1	-2.00	-2.00	-2.00	0.15	0.07	167302000	1145252300	2508633700	0.27	0.15	81095000	378096000	1401763500	2527959500	2019-09-30	9
13601	29	25880513.00	17845366.26	15918281.18	nan	nan	nan	156722650.00	137703953.85	115902164.84	0.10	4.95	4.38	4.40	2	8	19	0.25	0.11	-20700718.00	-12665571.26	-10738486.18	5179795.00	F	nan	nan	nan	nan	fff283aac89f4f82ab8b931dd9a9e41e	0	13941350.00	32960046.15	54761835.16	170664000.00	0	-1840000	24026700	38928300	nan	DVSN	0	1	3	4	0	0.33	0.25	5	0.00	1.00	1.00	0.60	0.39	158300000	262594000	410964000	0.12	0.09	0	24000000	192280000	253810000	2019-09-30	9
13602	29	1371899.00	1832260.38	2031132.77	nan	nan	nan	7853067.00	13069290.77	14585347.14	-0.08	2.30	2.31	2.01	0	1	2	0.00	0.00	-1371323.00	-1831684.38	-2030556.77	576.00	M	nan	nan	nan	nan	fff942970c8d4976993aa8e949f2c228	0	-7803017.00	-13019240.77	-14535297.14	50050.00	0	-870000	-2153100	-2153100	nan	HCM	0	2	3	3	0	0.67	0.67	1	-1.00	-1.00	-1.00	0.00	0.00	0	7000000	14200000	0.60	0.60	0	13330000	22156600	22156600	2019-09-30	9
13603	35	466813.00	3551778.28	2337714.13	nan	nan	nan	656058382.50	708738775.38	748528542.86	nan	1.00	1.00	1.00	1	1	1	1.00	1.00	0.00	-3084965.28	-1870901.13	466813.00	F	nan	nan	nan	nan	fff95069a1554792bfe041e2f7b184bc	0	81956317.50	29275924.62	-10513842.86	738014700.00	0	0	0	0	nan	DVSN	0	0	0	0	0	1.00	1.00	1	0.00	0.00	0.00	1.00	1.00	32720400	32720400	32720400	1.00	1.00	0	0	0	0	2019-09-30	9

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows